create or replace function is_number_test(as_parm in varchar2) return varchar2 is
  ln_id number;
BEGIN
  if is_number(as_parm) then
    return 111;
  else
    return 222;
  end if;
end is_number_test;
/
